﻿<?xml version="1.0" encoding="utf-8" ?>
<AdoNetDataAccess connection="$LocalizationDBConnection$" formatter="bizobj of UserSettings(defaultTimeZone)">
	<Sql>
		SELECT
			userId as id, defaultTranslation as translationId,  defaultTimeZone as defaultTimeZoneid,
			Languages.ISO6392
		FROM
			UserBasicSettings 
			LEFT OUTER JOIN Translations ON UserBasicSettings.defaultTranslation = Translations.id
			LEFT OUTER JOIN	Languages ON Translations.languageId = Languages.id
		WHERE
			UserId = @id;	
	</Sql>
	<Param name="id" type="UniqueIdentifier" />
</AdoNetDataAccess>